﻿CREATE TABLE [dbo].[Member] (
    [Id]                 UNIQUEIDENTIFIER NOT NULL,
    [Gender]             INT              NOT NULL,
    [Grade]              INT              NOT NULL,
    [Nickname]           NVARCHAR (20)    NULL,
    [Realname]           NVARCHAR (20)    NULL,
    [IdCardType]         NVARCHAR (20)    NULL,
    [IdCard]             NVARCHAR (50)    NULL,
    [Age]                INT              NULL,
    [Birthday]           DATE             NULL,
    [Height]             DECIMAL (9, 2)   NULL,
    [Weight]             DECIMAL (9, 2)   NULL,
    [Marry]              NVARCHAR (20)    NULL,
    [Child]              NVARCHAR (20)    NULL,
    [Education]          NVARCHAR (20)    NULL,
    [EducationValue]     INT              NULL,
    [Province]           NVARCHAR (20)    NULL,
    [City]               NVARCHAR (20)    NULL,
    [Salary]             MONEY            NULL,
    [Zodiac]             NVARCHAR (20)    NULL,
    [Blood]              NVARCHAR (20)    NULL,
    [Asterism]           NVARCHAR (20)    NULL,
    [Nation]             NVARCHAR (20)    NULL,
    [Religion]           NVARCHAR (20)    NULL,
    [Nationality]        NVARCHAR (50)    NULL,
    [RegisteredProvince] NVARCHAR (20)    NULL,
    [RegisteredCity]     NVARCHAR (20)    NULL,
    [Health]             NVARCHAR (20)    NULL,
    [Smoke]              NVARCHAR (20)    NULL,
    [Drink]              NVARCHAR (20)    NULL,
    [Exercise]           NVARCHAR (20)    NULL,
    [Monotropic]         NVARCHAR (20)    NULL,
    [QQ]                 NVARCHAR (20)    NULL,
    [HashMobile]         NVARCHAR (256)   NULL,
    [MobileVerified]     BIT              NOT NULL,
    [Occupation]         NVARCHAR (50)    NULL,
    [Income]             NVARCHAR (20)    NULL,
    [FriendType]         NVARCHAR (20)    NULL,
    [Life]               NVARCHAR (20)    NULL,
    [Dink]               NVARCHAR (20)    NULL,
    [Singleton]          NVARCHAR (20)    NULL,
    [Living]             NVARCHAR (20)    NULL,
    [Car]                NVARCHAR (20)    NULL,
    [House]              NVARCHAR (20)    NULL,
    [Trade]              NVARCHAR (20)    NULL,
    [TradeType]          NVARCHAR (20)    NULL,
    [WorkState]          NVARCHAR (20)    NULL,
    [IncomeDetail]       NVARCHAR (50)    NULL,
    [Company]            NVARCHAR (20)    NULL,
    [Department]         NVARCHAR (20)    NULL,
    [Duty]               NVARCHAR (20)    NULL,
    [Investment]         NVARCHAR (50)    NULL,
    [School]             NVARCHAR (50)    NULL,
    [Major]              NVARCHAR (20)    NULL,
    [Portrait]           NVARCHAR (1000)  NULL,
    [PortraitAudit]      INT              NULL,
    CONSTRAINT [PK_Member] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_Member_Declaration] FOREIGN KEY ([Id]) REFERENCES [dbo].[Declaration] ([Id])
);













